CREATE TABLE [dbo].[Publish_Server_Ref]
(
[PublishServerCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PublishServerDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SourceRootLocation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Frequency] [int] NOT NULL,
[PublishingSpeed] [int] NOT NULL,
[ServerIPAddress] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PollRequestInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IISSecurityUserName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IISSecurityPassword] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IISSecurityDomain] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Publish_Server_Ref_DefaultFlag] DEFAULT ('N')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Publish_Server_Ref] ADD CONSTRAINT [PK_Publish_Server_Ref] PRIMARY KEY CLUSTERED ([PublishServerCode]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Publish_Server_Ref] TO [IMIS]
GRANT SELECT ON  [dbo].[Publish_Server_Ref] TO [IMIS]
GRANT INSERT ON  [dbo].[Publish_Server_Ref] TO [IMIS]
GRANT DELETE ON  [dbo].[Publish_Server_Ref] TO [IMIS]
GRANT UPDATE ON  [dbo].[Publish_Server_Ref] TO [IMIS]
GO